Remove Duplicate Rows
AutomatR.DefaultActivities.Datatable.RemoveDuplicateRows
The "Remove Duplicate Rows" activity in AutomatR is designed to eliminate duplicate rows from a specified DataTable variable, retaining only the first occurrence. This activity aids in maintaining data integrity and consistency within workflows by ensuring unique rows within the DataTable.
Properties
| Name | Description |
|---|---|
| Input | |
| Data Table | Enter the DataTable variable from which duplicate rows need to be removed. DataTable variable or argument. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variable or argument containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Remove Duplicate Rows" activity. This can be useful for handling synchronization issues. Integer variable or argument containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Returns the DataTable with unique rows, free from duplicate occurrences. DataTable variable or argument. |
How to use:
- Drag and drop the "Remove Duplicate Rows" activity onto the workflow.
- Configure the properties by specifying the DataTable variable from which duplicate rows need to be removed.
- Optionally, configure the delay and customize the display name.
- Execute the workflow to obtain the DataTable with unique rows, removing any duplicate occurrences.
Example: Consider an example where the "Remove Duplicate Rows" activity is used to ensure unique employee records in a DataTable named "employeeData":
Remove Duplicate Rows:
Display Name: "Remove Duplicates"
Data Table: employeeData
Result: uniqueEmployeeData
In this example, the activity removes duplicate rows from the "employeeData" DataTable, retaining only the first occurrence of each unique row. The result is stored in the "uniqueEmployeeData" DataTable variable for further use in the workflow.